[PHP3] Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparison - Mailing list pgsql-general

From Paul DuBois
Subject [PHP3] Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparison
Date
Msg-id v04220500b41e653610ae@[144.92.43.105]
Whole thread Raw
In response to Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparison  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparison
[PHP3] Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparison
List pgsql-general
At 10:30 PM -0400 10/3/99, Bruce Momjian wrote:
>>
>>  What do/are the MySQL folks using for test data?  maybe start off with
>>  what they are using to time MySQL and then look at how PostgreSQL can do
>>  it, maybe differently?
>>
>>  Is there somewhere where the MySQL benchmarks can be downloaded from,
>>  including teh data?
>>
>
>Let me address my recollection of that discussion.  The basic issue is
>that MySQL is somewhat faster because they don't have any
>transactions/rollback capability, no user-defined types, and are SQL
>built on top of an ISAM-type file with the indexes inbedded in the file,
>so to add an index requires rebuilding the table.
>
>Second, the MySQL folks don't mention the features they _don't_ have,
>except now they mention they don't have transactions.

Uh ... what?  Chapter 5 of the MySQL manual goes into the missing
functionality in some detail.  I have never gotten the impression that
they're trying to hide what isn't present.

--
Paul DuBois, paul@snake.net

--
PHP 3 Mailing List <http://www.php.net/>
To unsubscribe, send an empty message to php3-unsubscribe@lists.php.net
To subscribe to the digest, e-mail: php3-digest-subscribe@lists.php.net
To search the mailing list archive, go to: http://www.php.net/mailsearch.php3
To contact the list administrators, e-mail: php-list-admin@lists.php.net



pgsql-general by date:

Previous
From: Paul DuBois
Date:
Subject: Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparison
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Re: [PHP3] Re: PostgreSQL vs Mysql comparison